package com.zygh.policeasset.mapper;

import com.zygh.policeasset.pojo.AssetOverhaul;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.type.JdbcType;

@Mapper
/* loaded from: police-asset-2.0-0.0.1-SNAPSHOT.jar:BOOT-INF/classes/com/zygh/policeasset/mapper/AssetOverhaulMapper.class */
public interface AssetOverhaulMapper {
    @Insert({"insert into asset_overhaul (asset_id, asset_type,overhaul_start_money,overhaul_remark,overhaul_status,overhaul_dotime,overhaul_depreciationperiod,overhaul_time,creat_time,stop_time)values (#{assetId,jdbcType=INTEGER}, #{assetType,jdbcType=INTEGER}, #{overhaulStartMoney,jdbcType=VARCHAR},#{overhaulRemark,jdbcType=VARCHAR},#{overhaulStatus,jdbcType=INTEGER},#{overhaulDotime,jdbcType=VARCHAR},#{overhaulDepreciationPeriod,jdbcType=INTEGER},#{overhaulTime,jdbcType=VARCHAR},#{creatTime,jdbcType=VARCHAR},#{stopTime,jdbcType=VARCHAR}) "})
    int add(@Param("assetId") Integer num, @Param("assetType") String str, @Param("overhaulStartMoney") String str2, @Param("overhaulRemark") String str3, @Param("overhaulStatus") Integer num2, @Param("overhaulDotime") String str4, @Param("overhaulDepreciationPeriod") Integer num3, @Param("overhaulTime") String str5, @Param("creatTime") String str6, @Param("stopTime") String str7);

    @Delete({"delete from asset_overhaul where  asset_id = #{assetId} and asset_type = #{assetType} and overhaul_status = #{overhaulStatus}"})
    int delete(@Param("assetId") Integer num, @Param("assetType") String str, @Param("overhaulStatus") Integer num2);

    @Select({"select * from asset_overhaul where asset_id=#{assetId} and asset_type=#{assetType}"})
    @Results(id = "AssetOverhaulMap", value = {@Result(column = "asset_id", property = "assetId", jdbcType = JdbcType.INTEGER, id = true), @Result(column = "asset_type", property = "assetType", jdbcType = JdbcType.VARCHAR), @Result(column = "overhaul_start_money", property = "overhaulStartMoney", jdbcType = JdbcType.VARCHAR), @Result(column = "overhaul_remark", property = "overhaulRemark", jdbcType = JdbcType.VARCHAR), @Result(column = "overhaul_status", property = "overhaulStatus", jdbcType = JdbcType.VARCHAR), @Result(column = "overhaul_dotime", property = "overhaulDotime", jdbcType = JdbcType.VARCHAR), @Result(column = "overhaul_depreciationperiod", property = "overhaulDepreciationPeriod", jdbcType = JdbcType.INTEGER), @Result(column = "overhaul_time", property = "overhaulTime", jdbcType = JdbcType.VARCHAR), @Result(column = "creat_time", property = "creatTime", jdbcType = JdbcType.VARCHAR), @Result(column = "stop_time", property = "stopTime", jdbcType = JdbcType.VARCHAR)})
    List<AssetOverhaul> findByIdAndType(@Param("assetId") Integer num, @Param("assetType") String str);
}